Film_Locations_in_San_Francisco

6 rows where Production Company = 177

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
1614	1614	Woman on the Run 304	1950 15	Former Hall of Justice (750 Kearny Street at Washington)		Fidelity Pictures Corporation 177	Universal Pictures 41	Norman Foster 247	Norman Foster 263	Ann Sheridan 350	Dennis O'Keefe 235	Robert Keith 202
1615	1615	Woman on the Run 304	1950 15	835-865 Market Street at 5th Street	The Emporium, a department store, stood in this location. Bloomingdale's is now located here.	Fidelity Pictures Corporation 177	Universal Pictures 41	Norman Foster 247	Norman Foster 263	Ann Sheridan 350	Dennis O'Keefe 235	Robert Keith 202
1616	1616	Woman on the Run 304	1950 15	819 Mason Street at Pine		Fidelity Pictures Corporation 177	Universal Pictures 41	Norman Foster 247	Norman Foster 263	Ann Sheridan 350	Dennis O'Keefe 235	Robert Keith 202
1617	1617	Woman on the Run 304	1950 15	772 Commercial Street at Kearney	Called "Man Loh's Oriental Roof Garden" in the film.	Fidelity Pictures Corporation 177	Universal Pictures 41	Norman Foster 247	Norman Foster 263	Ann Sheridan 350	Dennis O'Keefe 235	Robert Keith 202
1618	1618	Woman on the Run 304	1950 15	1801 Laguna at Bush		Fidelity Pictures Corporation 177	Universal Pictures 41	Norman Foster 247	Norman Foster 263	Ann Sheridan 350	Dennis O'Keefe 235	Robert Keith 202
1619	1619	Woman on the Run 304	1950 15	Cable Car Signal Box (California Street at Powell Street)	SF Cable Cars are the only moving National Historical Landmark.	Fidelity Pictures Corporation 177	Universal Pictures 41	Norman Foster 247	Norman Foster 263	Ann Sheridan 350	Dennis O'Keefe 235	Robert Keith 202

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");